From 79d4a6e13848111f8b39c7f68d66206e5ddc655a Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 4 Aug 2026 17:01:17 +0000 Subject: [PATCH] Enforce non-negative SIGHTING_RECORDS.Priority --- db/schemas/codes/tables/create/sighting_records.m4 | 1 + 1 file changed, 1 insertion(+) diff --git a/db/schemas/codes/tables/create/sighting_records.m4 b/db/schemas/codes/tables/create/sighting_records.m4 index c144c41..a29e9fb 100644 --- a/db/schemas/codes/tables/create/sighting_records.m4 +++ b/db/schemas/codes/tables/create/sighting_records.m4 @@ -28,6 +28,7 @@ CREATE TABLE sighting_records ( emptytext_check(`Code') nospaces_check(`Code') ,priority INTEGER NOT NULL + nonnegative_check(`Priority') ,description TEXT NOT NULL notonlyspaces_check(`Description') CHECK ((code = 'sdb_manual_source' -- 2.34.1